It's all about the answers!

Ask a question

Fulltext Query result hides some work items - why?


Doreen Engling (53132) | asked Dec 03 '09, 6:02 a.m.
We are using RTC 2.0.1.
Because of bug (tag search is buggy)

https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=98393

we have tried to get certain work items by a query with Full Text search. -Full Text contains- It seems it works but we don't get all expected work items. And in the header of the work item view is also written: "Showing 100 (of 109 work items containing "keyword ") I have checked the missing items regarding content. There is no difference to the others which are shown in the list.
Has anyone an idea?

3 answers



permanent link
Work Item & UI Commons Team (1.3k1) | answered Dec 03 '09, 7:08 a.m.
On 03.12.2009 12:08, dengling wrote:
We are using RTC 2.0.1.
Because of bug (tag search is buggy)

https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=98393

we have tried to get certain work items by a query with Full Text
search. -Full Text contains- It seems it works but we don't get all
expected work items. And in the header of the work item view is also
written: "Showing 100 (of 109 work items containing
"keyword ") I have checked the missing items regarding
content. There is no difference to the others which are shown in the
list.
Has anyone an idea?


Fulltext results are used as input to a query that is then send to the
database. We have some logic to limit the number of results returned
from the fulltext search (e.g. low score, limit). In general the best
way to avoid this is to use a more fine grained fulltext query and not
to use words that are commonly used across items.

--
Benjamin Pasero
Work Item & UI Commons Team

permanent link
Patrick Streule (4.9k21) | answered Dec 03 '09, 2:38 p.m.
JAZZ DEVELOPER
Benjamin Pasero wrote:
On 03.12.2009 12:08, dengling wrote:
We are using RTC 2.0.1.
Because of bug (tag search is buggy)

https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=98393


we have tried to get certain work items by a query with Full Text
search. -Full Text contains- It seems it works but we don't get all
expected work items. And in the header of the work item view is also
written: "Showing 100 (of 109 work items containing
"keyword ") I have checked the missing items regarding
content. There is no difference to the others which are shown in the
list.
Has anyone an idea?


Fulltext results are used as input to a query that is then send to the
database. We have some logic to limit the number of results returned
from the fulltext search (e.g. low score, limit). In general the best
way to avoid this is to use a more fine grained fulltext query and not
to use words that are commonly used across items.


You can also increase the setting (Full text merge limit, default: 100)
in the Admin Web UI. This will come at the price of impaired
performance, however.

We are investigating a better solution for 3.0

--
Regards,
Patrick
Jazz Work Item Team

permanent link
Doreen Engling (53132) | answered Dec 04 '09, 9:00 a.m.
Benjamin Pasero wrote:
On 03.12.2009 12:08, dengling wrote:
We are using RTC 2.0.1.
Because of bug (tag search is buggy)

https://jazz.net/jazz/web/projects/Rational%20Team%20Concert#action=com.ibm.team.workitem.viewWorkItem&id=98393


we have tried to get certain work items by a query with Full Text
search. -Full Text contains- It seems it works but we don't get all
expected work items. And in the header of the work item view is also
written: "Showing 100 (of 109 work items containing
"keyword ") I have checked the missing items regarding
content. There is no difference to the others which are shown in the
list.
Has anyone an idea?


Fulltext results are used as input to a query that is then send to the
database. We have some logic to limit the number of results returned
from the fulltext search (e.g. low score, limit). In general the best
way to avoid this is to use a more fine grained fulltext query and not
to use words that are commonly used across items.


You can also increase the setting (Full text merge limit, default: 100)
in the Admin Web UI. This will come at the price of impaired
performance, however.

We are investigating a better solution for 3.0

--
Regards,
Patrick
Jazz Work Item Team

Thanks for hint. I have increased the value to 200. But i get now only 107 instead of the expected 109 items. That is strange.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.